﻿CREATE TABLE [dbo].[Process] (
    [ProcessID] INT              NOT NULL,
    [Priority]  INT              NULL,
    [MemUsage]  INT              NULL,
    [ServerID]  UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_Process] PRIMARY KEY CLUSTERED ([ProcessID] ASC, [ServerID] ASC),
    CONSTRAINT [FK_Process_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

